<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> 
--%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<jsp:useBean id="actions" scope="application" class="DataAccess.Actions"/>
<%
//utenti.setConnectionString("jdbc:microsoft:sqlserver://ormt189:1433;DatabaseName=ariellab;user=test;password=test");

//articolo.setDriverString("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//articolo.setConnectionString("jdbc:microsoft:sqlserver://ormt189:1433;DatabaseName=ariellab;user=test;password=test");
actions.setDriverString("com.mysql.jdbc.Driver");
actions.setConnectionString("jdbc:mysql://127.0.0.1/carta?user=root&password=");
//actions.setConnectionString("jdbc:mysql://127.0.0.1/andreafortuna?user=andreafortuna&password=asturias");
//Integer id_articolo = request.getParameter("id_articolo");

//String id_action=request.getParameter("action");
String id_stato = request.getParameter("id_stato");
%>

<%=actions.getTableFromQuery("select province.id_provincia as ID,province.sigla_provincia as Sigla ,province.nome_provincia as Nome, regioni.nome_regione as Regione from province, regioni where province.id_regione = regioni.id_regione and regioni.id_stato = " +  id_stato ,"ID", "index.jsp?action=modifica_provincia&operazione=modifica&id_provincia=", "index.jsp?action=modifica_provincia&operazione=elimina&id_provincia=")%>